Hello, i would like to know if a cell has a text value (eg P - for present), can there be a formula or rule that will shade the colour of the cell a particular colour if a certain text is entered? eg for "P" in the cell, the cell colour would turn yellow, and for "A" in the cell the cell colour would turn red. Thank you
Solved by G. A. in 21 mins