Conditional Formatting Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my spreadsheet I have a list of training due dates. I would like to setup
a conditional formatting function to the entire spreadsheet that if anyone is
due training on or before July 01, 2006 to turn the field yellow. What would
the formula be and how can I apply it to the entire sheet or do I have to
apply it cell by cell.

Thanks
 
Suppose your data is from A2:D6 and row 1 has column headings and the
training dates from col A2 to A6. Enter 1-Jul-06 in E2
Select the col A2:D6
Go to Format>Conditional formatting
Select Formula is from the drop down below condition1 and enter
=($A2<=$E$2)) in the next cell and select format and select any colour
from patterns and say apply
 
Back
Top