ExcelBanter - Cells changes colour if....

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cells changes colour if.... (https://www.excelbanter.com/excel-worksheet-functions/173978-cells-changes-colour-if.html)

Derek

Cells changes colour if....

Hi all

I wonder if you can help with this one

I would like cell G6 to change to green if cells B6, E6 and F6 have a Y in
them, is this possible? im using office 2007

Many thanks

Derek

David Biddulph[_2_]

Cells changes colour if....

Format/ Conditional Formatting/ Formula Is/ =AND(B6="Y",E6="Y",F6="Y")
Choose your green colour in the format.
--
David Biddulph

"Derek" wrote in message
...
Hi all

I wonder if you can help with this one

I would like cell G6 to change to green if cells B6, E6 and F6 have a Y in
them, is this possible? im using office 2007

Many thanks

Derek

All times are GMT +1. The time now is 05:06 PM.