Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting row

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting by row

Conditional Formatting by row

ResolvedVersion 2010

Alisdair has attended:
Excel Intermediate course

Conditional Formatting by row

Hi,

I am trying to format my tables so that if one of the cells in the row shows a certain value the entire row will go a certain colour. The three possible values are 0, 1 and 2 and I want the colours to be green orange and yellow.

I have managed to do this for a single row by highlighting the row and entering a rule with the formula =$F$5=2 and formatting the colour I would like. I cant seem to be able to do this for the table however, and when I try to copy it still works from whatever the value in the first cell is.

Can you please help?

RE: Conditional Formatting by row

Hi Alisdair

Thank you for your question - that formula will almost do the trick. The only thing that needs removing is the $ before the number 5.

By removing that your format can be applied to the other rows using format painter.

Let me know if that solves the problem.

Thanks,
Andrew

Fri 14 Apr 2017: Automatically marked as resolved.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.