On 30 Apr, 14:06, 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.
--
Traa Dy Liooar

Jock

Hi Jock

In Cell Y1
Open the Conditional Formatting dialog box,
select "Formula Is",
type =Y1=""
Click Format
Click Pattern
Select the grey colour you want,
OK, OK,
Copy Y1 to the required cells (Pastespecial Formats if necessary to
avoid pasting over existing values)

Regards

Steve