Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: excell help
liam.mccaffrey

posted on 2/2/07 at 11:02 AM Reply With Quote
excell help

i want to automatically colour fill a cell with a specific colour depending on the date contained in another cell, any idea how to do it. i need to keep the text in the cells also.

for example.

IF the date in cell A10 is before the current date. highlight cell A1 in red

Many thanks

[Edited on 2/2/07 by liam.mccaffrey]





Build Blog
Build Photo Album

View User's Profile View All Posts By User U2U Member
drlloyd

posted on 2/2/07 at 11:04 AM Reply With Quote
You need to use Conditional formatting mate. You can find it under the 'Format' drop down menu.
View User's Profile View All Posts By User U2U Member
flak monkey

posted on 2/2/07 at 11:06 AM Reply With Quote
Yep conditional formatting.

Just use a if statement and apply it to the cells in question. Should do it...





Sera

http://www.motosera.com

View User's Profile Visit User's Homepage View All Posts By User U2U Member
liam.mccaffrey

posted on 2/2/07 at 11:17 AM Reply With Quote
i know about conditional formatting, theres already a lot of it on my sheet.

what i think i need to do now is conditionally format with a couple of IF and OR's

I think ive sussed it now when i looked at it first it seemed more complicated than it was





Build Blog
Build Photo Album

View User's Profile View All Posts By User U2U Member
Humbug

posted on 2/2/07 at 11:23 AM Reply With Quote
you need to select Formula instead of Cell

e.g. if you want to colour Cell A2 depending on what is in A1, you would do something like:

1. position the cursor on A2
2. Format->Conditional Formatting
3. Formula is =A1="RED"
4. Click Format
5. Click Patterns, select the red colour and click OK
6. Click OK again

Then, if A1 contains RED, cell A2 will be coloured red

You can add up to 3 conditions for a given cell

have fun!

View User's Profile View All Posts By User U2U Member
liam.mccaffrey

posted on 2/2/07 at 12:16 PM Reply With Quote
cool done it now thanks chaps
used
=OR($I$82<TODAY(),$L$82<TODAY())
for condition 1
=OR($I$82<TODAY()+550,$L$82<TODAY()+550)
for condition 2

this will highlight the cell red if its over due and pink if it goes out of compliance within 18 months of todays date





Build Blog
Build Photo Album

View User's Profile View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content © 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [© 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.