0

I want to get a cell to highlight is the value in cell V16 is greater than 0. I then want it to check if S5=D17. If this is True, no action is required. But if it is False, I want it to highlight.

=IF(V16<0,S9=D37,"highlight D37 red")

Improve this question
2
  • Try: =NOT((V16>0)*(S5=D17))
    – Mayukh Bhattacharya
    Commented May 25 at 21:11
  • Use Conditional formatting (Use a formulae to determine which cell to format) to achieved the same. Add condition and apply format.
    – Arun Singh
    Commented Jun 3 at 9:20
Related questions
593
How to do a logical OR operation for integer comparison in shell scripting?
0
Highlight row range if column value is greater than zero
268
Return empty cell from formula in Excel
Load 3 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.