Conditional Formatting of a Row

M

Mike McLellan

I have a spreadsheet with a number of similar rows and I want to be able to
set the background colour of each row to cyan if the contents of cell
Rx="Completed". Is there a simple way to do this other than setting up a
conditional format entry for each individual cell?
 
D

Dave Peterson

Select the range to apply the conditional formatting:
A2:X999 (say)

Write your formula against the row with the activecell:
=$r2="Completed"

And apply your formatting.
 
S

Stefi

Select the range you want to conditionally format, say A1:R100,
Use this formula in CF:

=$R1="Completed"

Regards,
Stefi

„Mike McLellan†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top