WYLIE
05-18-2012, 03:48 AM
* Typo in the header please read below
Condtional format but if Cell next displays "Y" condtionalColour should be green
Hi
I'm using conditional formatting as a "traffic lights" system referring to a chase date of post we are waiting to receive from a client.
My aim is to use colour green as green as received when "Y" is entered in column H
And
IF the cell(s) in column H does not contain "Y" display AMBER colour as waiting or RED Colour if the (Chase) date has passed.
NB 1: Please find attached the template I am using; Personal information has been deleted from spreadsheet.
NB 2: I can use simple date conditional format but comparing with another cell I am having difficulty with.
Thankyou for looking at my query
Condtional format but if Cell next displays "Y" condtionalColour should be green
Hi
I'm using conditional formatting as a "traffic lights" system referring to a chase date of post we are waiting to receive from a client.
My aim is to use colour green as green as received when "Y" is entered in column H
And
IF the cell(s) in column H does not contain "Y" display AMBER colour as waiting or RED Colour if the (Chase) date has passed.
NB 1: Please find attached the template I am using; Personal information has been deleted from spreadsheet.
NB 2: I can use simple date conditional format but comparing with another cell I am having difficulty with.
Thankyou for looking at my query