CODEWITHSUNDEEP
excel
geotheory
geotheory

Reputation: 23640

Conditional formatting many cells by individual formulae

I want to apply a conditional formatting (CF) rule to a group of cells to individually colour them if their individual cell values are greater than a threshold (in this case >=5). To illustrate:

enter image description here

The top row shows how I want the bottom row to look. For the bottom row I cannot figure out how correctly format according to cell-specific formulae.

The problem is identifying a way to specify cell-specific CF formulas in a single operation for a group of cells - as you can by pasting/dragging normal cell formulas. I obviously don't want to have to manually specify the formula for each cell!

Grateful for assistance.

Upvotes: 0

Views: 285

Answers (2)

Karpak
Karpak

Reputation: 1927

You just select all required cells to format. Then go to conditional formatting.

Check what is the cell shown just before the formula bar (the single cell that represents the selected range, also called default cell) and use that cell in your formula without absolute reference. like B3>=5 or R3>=5

Upvotes: 0

Gowtham Shiva
Gowtham Shiva

Reputation: 3875

Select the rows or columns or range that you want to conditional format,

Enter the below formula in the formula bar in conditional format and choose a fill color,

=AND(A1>=5,ISNUMBER(A1))

enter image description here

If you are starting in row3, change the A1 to A3. The $ that you have in the formula makes it absolute. It should be relative.

Upvotes: 1

Related Questions