Previous Topic Next Topic

Diffrent formula in one column

Closed
Arif - Jan 23, 2012 at 01:14 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 28, 2012 at 10:27 PM
Hello,
I am using Excel 2007 I used conditional formatting for the selected area example I wanted that if the figures in column E get higher then column F then show in red color and it works, now my question is this that in Column F some figures are 0 or blank even so i dont want that it shows in Column E in red it should remain as it is normal the worksheet I am working on is contain alot of data so i cannot apply one by one on all of them can you please help,



1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 28, 2012 at 10:27 PM
use something like this formla(modify it if neessar) in the conditional formatting window
the conditon is "formula is"

=and(E1>=F1,F1<>0)
0

Similar discussions

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

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response