Previous Topic Next Topic

If/Then Excel Question

Closed
Mike - 24 Mar 2011 à 08:52
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 24 Mar 2011 à 08:57
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

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

=D2>B2
=B2>D2

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
How to extract data from one excel file to another
zamorin -
zamorin -

2 responses