# Condition is - How to highlight Cell Value via other cell "TRUE" OR "FALSE" value (if "K1" = FALSE after change cell color to Red) (No VBA)

[krunal123]

@ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)

 

[jasonb75]

You don't need K2 to do that, if the rule is not to highlight when H2=20 then you simply highlight when H2 doesn't equal 20

Conditional format rule =H2<>20

 

[krunal123]

You don't need K2 to do that, if the rule is not to highlight when H2=20 then you simply highlight when H2 doesn't equal 20

= i have need K2 because its match between H2 ..................like i have fix value on k2 , so may be change h2 value after change Cell color is RED like alert.

 

[jasonb75]

You have a fixed value of 20 in K2 as a criteria for H2, if you enter that as a conditional formatting rule like I said then you do not need K2.