Conditional formatting

[NAVEEN C N]

I want to format the rows based on battery voltage value.

If battery voltage < 3500 - Red

battery voltage is between 3500-3750 = yellow

battery voltage > 3750 = Green

Please find attached file for your reference...

Thanks in advance..

 

[Khalid NGO]

Hi Naveen,

Select your range: Go to Home Tab --> then select conditional formatting
--> Highlight cells
--> Less Than --> put the required value and select the required color/formatting --> Click Ok

Same procedure for between and less than

Best Regards,
Khalid

 

[Khalid NGO]

You can check the file also.
Just apply CF for Greater than values by yourself.

 

[Somendra Misra]

Hi Naveen,

See the file.

Regards,