Setting cell fill colour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jacetech - 16 Mar 2008 13:58 GMT

I would like to compare an active cell with another cell and dependant upon
whether the active cell is greater than, equal to or less than the
comparision cell I would like to set the fill colour of the active cell to
either red, white or green. Any help would be appreciated.

Reply to this Message

Mike H - 16 Mar 2008 14:17 GMT

Hi,

Conditional formatting may be what you want:-
Select your cell(s) and then
format|Conditional format
cell value is select 'Greater than" enter =$B$1 and pick a colour
Click add and repeat for equal to
Click add and repeat for less than
Click OK

Mike

> I would like to compare an active cell with another cell and dependant upon
> whether the active cell is greater than, equal to or less than the
> comparision cell I would like to set the fill colour of the active cell to
> either red, white or green. Any help would be appreciated.

Reply to this Message

Jacetech - 16 Mar 2008 16:46 GMT

Mike

Thank you for this but it doesn't cover everything I need to do. I have a
range of target dates when something should happen, I then enter the date the
action happened, at this stage I want to compare the 2 dates to change the
cell I have just entered a date into a specific colour. White to signal on
time, green for early and red for late. The time scale could be weekly over
many years. I was looking at using a cell changed type event to code the
check and colour change in.

I hope this clarifies things

Jacetech

> Hi,
>
[quoted text clipped - 12 lines]
> > comparision cell I would like to set the fill colour of the active cell to
> > either red, white or green. Any help would be appreciated.

Reply to this Message