ExcelBanter - IF function for cell color

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

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

- - IF function for cell color (https://www.excelbanter.com/excel-worksheet-functions/89974-if-function-cell-color.html)

Clark

IF function for cell color

I really don't want to use conditional formatting in my spreadsheet. I want
a certain cell to "shade" a color if it sees text in another cell. It is a
pain to copy the CF to all of the other cells, as I have about 365 of them to
do. Can anyone provide an easier answer?

voyage2000UK

IF function for cell color

I'm crap as far as excel goes, so don't confuse me with an expert.
Maybe you could creat a macro for the conditional formating of 365
cells. Just a thought.

All times are GMT +1. The time now is 04:53 AM.