Hi,
and Hi Biff,
with the required range selected, and the first cell (A1 in my formula)
the active cell (the odd colour highlight)
in the first condition - formula
=AND(MOD(ROW(),2)=1,A1=0)
in the second condition - formula
=(A1=0)
in the third condition - formula
=MOD(ROW(),2
Seems to work for zero = (font red) and/or row = odd (pattern =
colour)
Hope this helps
--
Smurfette Wrote:
Thanks for your help, Biff and Bryan.
Biff, your method works a treat. Bryan, I am interested in getting
yours
right too, for the learning. I tried something similar to what you
proposed,
but got stuck in the first condition when specifying the value. For
example:
1. Formula Is: =AND(MOD(ROW(),2)=1,CellValueIs=O)
How do I write the "Cell Value Is" part, so that I don't have to
specify an
actual cell (eg A10=0), but rather refers to the cell being formatted?
Sorry, could be very simple...I discovered conditional formatting about
2
hours ago!
Many thanks,
Deb
"Biff" wrote:
Yes, that does work!
Biff
"Bryan Hessey"
wrote in message
news:Bryan.Hessey.26unrm_1146018300.9619@excelforu m-nospam.com...
Try 3 conditions,
first = AND( row , values) -- shading and red font
second = rows -- shading
third = values -- red font
Hope this helps
--
Smurfette Wrote:
Hi there,
I've applied Formula is =MOD(ROW(),2)=1 and selected a shading
colour
for my
table. However, if the cell values = 0, I want the numbers to be
red.
Can't seem to get it to work, as when both conditions are true,
the
second
one gets ignored. Perhaps it's to do with OR/ AND statements?
Help appreciated!
Thanks,
Debbie
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=536233
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=536233