Conditional Formatting help

[Mohandas]

I need conditional formatting in f column basis g column

if it is less than or equal to g column value it is green

more the 5 in g colums value it is amber

more than 10 it is red

Please help

 

[NARAYANK991]

Hi ,

Something like this ?

Narayan

 

[Ramesh]

see if this help...!

 

[Mohandas]

Can the have text basis the colour in the G columns instead the numbers

 

[Ramesh]

Hi,

Can you elaborate your question little more please.. I could not understand what you are referring to!!

If your question is related to conditional formatting based on text values, then you will modify the Conditional formatting rule as follows:

G3="Not Met" - Apply Red color
G3="Almost Met" - Apply Amber color
G3="Met" - Apply Green color

Thanks,
Ramesh

 

[Mohandas]

I mean to say i need text in the cell G3 if it is red colour as "Overdue",Green as OK and amber as "Due"

 

[Ramesh]

Here you go.. I have added this conditional formatting in column H and created the required conditional formatting rules..

 

[bosco_yip]

Conditional Formatting rules as in G3:G19 :



Regards
Bosco