conditional formating

A

Allan

Using Excel, Is it possible to have a result in one cell apply conditional
formatting to adjacent cells?
 
F

Frank Kabel

Hi
yes it is :)
Try:
- select cell A1
- in the conditional format enter the formula
=$B$1="value"
- choose your format
 

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 does not accept text format! 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Changing row background from external program 0
Conditional format 1
Conditional Formatting 3
Need Help with a VBA subroutine 0
Conditional Formatting Amendment 2
How can i put text in a cell depending on colour 0

Top