Hi, Im trying to do some conditional formatting based on certain cells. I'm limited to what I can show so hopefully this is enough to go on.
The logic I need is:
Show green if(and...N2=yes, o2=0,p2=0,q2=0, r2/s2/t2 all equal g2....Show yellow if not all the previous are true but x2=yes....otherwise show red?
Is this possible? Any help would be appreciated. thanks!
set up a couple of rules using formulas in conditional formatting
=AND( N2="YES", O2=0, P2=0, Q2=0, R2="G2", S2="G2", T2="G2")Show green if(and...N2=yes, o2=0,p2=0,q2=0, r2/s2/t2 all equal g2....Show yellow if not all the previous are true but x2=yes
for green
new rule
=AND( N2="YES", O2=0, P2=0, Q2=0, R2="G2", S2="G2", T2="G2", X2="YES")
for Yellow
So any condition is RED - even if blank cells ?
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for the quick response!
On second thought I'd only like to format for green and yellow.I'll leave all others blank
The formula as is didnt' work for me..for simplicity lets try this logic
Show green if(and...N2=yes, r2/s2/t2 all equal g2 (cell reference not value)....Show yellow if not all the previous are true but x2 (cell reference not value)=yes.
Would I need to use $ for anything in the formula?
try
=AND( N2="YES", O2=0, P2=0, Q2=0, R2=G2, S2=G2, T2=G2)
i thought G2 was text not a cell
dont understand this
.Show yellow if not all the previous are true but x2 (cell reference not value)=yes.
Thanks for the help! I failed to mention I needed to copy the formatting down 365 rows, so I added a $ before each cell reference and it worked.
For the yellow. I just created a second condition that said if cell x2=yes then format yellow.
excellent glad it worked OK
thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks