advanced conditional formatting

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

How can I change the colour of a range of cells depending
on the value in a specific ONE of those cells?

For example, there are school applications. If I
type 'yes' in a cell with the column heading "CANCELLED"
then I want ALL the cells in the row to change to grey,
not just the cell where I typed "Yes".

Is this possible?

Thanks
 
Hi Chris

yes, assuming column D is the one with Cancelled as its heading and your
heading is row 1 and the data starts at row 2

select from row 2 to the end of your data range by dragging down the row
numbers
and then choose from the menu
Format / Coditional Formatting
Choose
Formula Is
and type
=$D2="yes"
click the format button and set the format you want
click OK twice

Regards
JulieD
 
Hi
try the following:
- assumption column B contains this column heading:
- select the rows (assummption starting in row 2)
- in the conditional format dialog enter the formula:
=$B2="yes"
- choose a format
 
Try this ..

Suppose your table is in A1:D11,
headers in row1,
data from row2 down
and col D's header is "Cancelled"

Select A2:D11

Click Format > Conditional Formatting

Under Condition1, make the settings:
Formula Is| =TRIM($D2)="Yes"
Click Format button > Patterns tab > grey > OK

Click OK at the main dialog

Try entering "Yes"* in some cells in D2:D11

The rows will be colored grey

*non-case sensitive
 
Back
Top