Home » Forums » Open Source Learning Center » Question and Answer

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

Submitted by manishdhaked on 2 March, 2013 - 04:49

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

‹ VBA EXCEL GAUSS SEIDEL How to automatically get zodiac signs (based on date ranges) ›
»
Almir's picture

Yes, it is possible...

Submitted by Almir on 2 March, 2013 - 16:29.

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.

»