Conditional Formatting

  • Thread starter Thread starter thanos_titan
  • Start date Start date
T

thanos_titan

Am trying to produce a checklist or scorecard that uses the tradition
traffic light colors to indicate levels or risk. Is there a way,
without merging cells, so that if say cell A5 meets the criteria for a
Red and white conditional format, the Cells B5, C5, D5 and E5 are also
Red and white conditionally formatted?

Thanks,
Thanos
 
Click on The cells you want conditionally formatted with A5's change in
value
Open conditional formatting in
Change it to Formula is

Write your formula with a fixed reference to (eg =$A5>3)

Select your formatting colours

OK

Steve
 

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

Similar Threads

Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
Conditional Formatting 1
Conditional formatting comparing times 12
Conditional formating a cell containing a date 1
Comparison of columns using Conditional Formatting 3
Conditional format cell containing hyperlink 2
conditional formatting based on different cells with more conditio 1
proper writing of a formula 8

Back
Top