CF to grey out the two unused options
Perfect, Thank you
--
Traa Dy Liooar
Jock
"Glenn" wrote:
Jock wrote:
The user has the option of entering a date in either of cells Y,Z or AA on
any given row. If Z is picked, for example, I would like the 2 unused cells
on the same row to be greyed out. If the date is then removed and put in AA,
then the CF would grey out the other 2 unused cells.
=AND(Y1="",COUNT($Y1:$AA1)0)
|