colour the row containing text "POSTED TO G/L" and above 3 rows with conditional formating

Hi All,

my problem is that i want to colour the row containg text "POSTED TO G/L" and above 3 rows i.e, whichever row contains "POSTED TO G/L" that row and above 3 rows are to be coloured using conditional formating.

NOTE: The text "POSTED TO G/L" appears in only coloumn A.

any help regarding this would be apprerciated.

thanks in advance

Regards,
Manish

Almir's picture

Yes, it is possible...

Try this:

Suppose that you have selected A1 cell and chose Conditional Formatting:

=OR(A4="POSTED TO G/L";A3="POSTED TO G/L";A2="POSTED TO G/L")=FALSE

Copy formatting downwards and that's it.