Hello all
I would like to be able to use conditional formatting so that when I
enter a value in a cell it highlights the first 4 cells in that row.
There is already a formula in place that means all cells from
E5:LZ203 highlight green if a value is entered (=NOT(ISBLANK(E5)).
Eg: I have entered 2 into cells V6:W6 and they go green.
However in addition what I would like to happen is that the first 4
cells in that row change colour (basically means its planned). In
this case A6:D6.
Help!
Not clear on what you're trying to do, but sounds like you just need to
copy the CF to cels ib A:D for the desired rows.
Also, be aware your CF formula uses 2 functions where a single function
would suffice (and be more efficient)...
=LEN(E5)
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus