I am trying to do a conditional format for an entire column that will put a specific number in column F, if column E is greater than 0. I can get the formula to work if I just enter in the cell, but I can not get formula to work on conditional formatting.
Last edited by tvonbehren; 11-07-2011 at 03:52 PM.
Put this formula into the conditional formatting for cell F1, then copy the formatting down to the bottom of the column:
=E1>0
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Thank you. I have tried that. I am looking for the value 5 in column F, if column E is greater than 0 and if column E is equal to 0 then remain blank.
I have tried entering this code in the conditional fomatting formula rules manager but returns nothing in cell.
[code]=($E:$E>0,5,"")[code]
Just put =E1>0, then copy the format down the whole column. You can't use E:E in the conditional formatting. Be sure to use relative references.
Thank you Davegug, I appreciate the help. This worked for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks