Conditional Formatting

J

John Pivot Table

How can I use conditional formatting for a value inside a cell? For example I
have a cell with the value V10 inside and I want to trigger conditional
formatting only with V not by the V10.
 
F

FSt1

hi
try something like this....
data in g7...adjust to suit..
select g7 and in the CF dialog.....
formula is......=IF(LEFT(G7,1)="v",1,0).....,pick your format

regards
FSt1
 

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 Highlighting duplicates 0
Conditional Formatting 3
Excel conditional formatting with Weeknum 4
Excel Conditional Formatting Removal 7
Conditional Formatting for entire row 4
Changing cell colors from a function command 3
conditional formatting update issue 5
Apply Conditional Formatting to other rows 6

Top