Solved How to use conditional formatting for a specific function

October 26, 2016 at 10:28:23
Specs: Windows 7
Hello, I have been learning how to set conditional formatting to my spreadsheets, but I can't seem to format this:

if cell B1 says "refi" then row 15 turns gray with strikeout.


See More: How to use conditional formatting for a specific function

Report •

#1
October 26, 2016 at 11:08:25
✔ Best Answer
Try this:

Conditional Formatting 2007

1) Select your cell or range of cells, IE all of row 15
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:

=$B1="refi"

6) Click on the Format button
7) Select Font Tab
8) Click on the Button next to Strikthrough
9) Select the Fill Tab
10) Select a Gray color
11) Click OK
12) Click OK

Note the Dollar Sign - $ before the letter B in the cell
reference B1, it is required if you want to color the entire row.

And Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Report •

#2
October 26, 2016 at 11:39:59
Thankyou so much! That worked...I was trying very similar formulas but was JUST off!!

Report •
Related Solutions


Ask Question