conditional colour fill a row - based on cell value =100%

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I am trying to format a row so as if a certain cell value on that row = 100%,
then the row will be colour filled a certain colour.
 
Greg --

Select the row by clicking the number on the left-hand side. Click
Format>Conditional Format. Change 'Cell Value Is' to 'Formula Is' and, in
Click to expand...
the next field, type =$A$1=1. Replace the $A$1 with whatever your key cell
is. Then click the format buttons to format the cells the color you want,
and click OK.

HTH
 

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 Formula to colourfill cells when condition met 2
conditional formating adjacent rows 4
colour numbers 2
Sum if cell = grey 4
Function for summing or counting cells based on a specified fill color 2
Excel Excel 2013 conditional formatting 1
Excel Conditional Formatting Removal 7
Excel 2007 conditional formatting & cell colour. 2

Back
Top