IF condition with conditional formatting

[avinashraste]

Hello,

I have an excel sheet containing Name & rate columns. For eg. abc - 25000, xyz - 30000, jkl - 15000. Now i want to add an if condition that IF the rate (B2) is less than 20000, THEN colour (A2) with Green, else No Clour.

That means based on the rate cell, I want to change the colour of Name cell.

Is this possible ? Please guide & help.

Thanks & Regards

Avinash Raste

 

[VoG]

Select the names, in CF use Formula Is with the formula

=B2<20000

and set a format.

 

[avinashraste]

Dear VoG,

Thanks for the early reply. I tried but could not get the result. What I want is If B2 is Less than 20000 then A2 will be coloured else no colour. If B3 is less than 20000 then A3 will be colured else no colur, if B4 is less than 20000 then A4 will be colured else no colour. This will go on for 300 rows.

So can you pls guide, how do I do that ?

Thanks & Regards

Avinash Raste

 

[VoG]

Like this: select the whole range in column A and apply the CF formula

Excel Workbook
	A	B
2	V	14999
3	S	14864
4	H	23666
5	F	24681
6	E	12938
7	Z	14099
8	W	17146
9	B	16547
Sheet8

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =B2<20000	Abc

 

[avinashraste]

Dear VoG,

Superb.
Thanks a lot sir. This is exactly how I wanted. Thank you once again.

Thanks & regards

Avinash Raste