Previous Topic Next Topic

If/Then Excel Question

Closed
Mike - Mar 24, 2011 at 08:52 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2011 at 08:57 AM
Hello,

I'm trying to get the If / Then function to do what I want and apparently I'm missing something.

For example,

If d2 is greater than b2 then red font, if d2 is less than b2 then bluefont.

Seems simple enough but I can't seem to get it to work just right!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 24, 2011 at 08:57 AM
You need to use conditional format and need to have two conditions there

=D2>B2
=B2>D2
0

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses