Hi Guys
My first post.
I have a spreadsheet, which I use as a track for work.
When I type "SPQ" into a cell, I want the 4th cell on the right to turn red? How can I do this?!
I would like this for every single cell, so any cell I type "SPQ" into, the 4th cell on the right goes red no matter where it is within the spreadsheet?!
Thanks in advance
Hello Sam & Welcome to the Forum,
I can't think of a way to have conditional formatting do this, so you might be VBA.
Do you want to go with VBA?
HTH
Regards, Jeff
Are you sure about that?Originally Posted by SamTB
There are 1,048,576 cells per column * 16,384 columns = 17,179,869,184 cells per worksheet.
How about narrowing it down to a reasonable range of cells!
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tony,How about narrowing it down to a reasonable range of cells!
Even with a narrowed range, can this be done via CF?
I'm thinking that once we find out what the OP really wants (and where it should happen) it should be doable.
Try this CF formulanarrowing it down to a reasonable range of cells
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Could be done with something like this:
=OFFSET(Cell_Ref,,-4)="SPQ"
@ Willem...
I didn't download your file.
Why is your file a macro enabled file?
Did you use VBA to do this?
No I always use XLSM files
Thanks! However the cell to the right on the row below where I put SPQ goes red? How can i get it on the same row?
Not in my file
Show us your file where it is going wrong.
Silly question, how do I upload my file?! Which I click on the attatchments icon nothing happens?
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
Hopefully that's worked?
Change:
inPlease Login or Register to view this content.
Please Login or Register to view this content.
Thank you so much! What would I have to change If i wanted the cells to go further apart? for example the 5th/6th/7th cell to go red?
Once again, thank you!!!!
thanks so much, but for example what would I do if I wanted the 6th cell to go red? what would i have to change? thanks so much again
Formula: =A3="SPQ"
Range : =$D$3:$OE$31
A is column 1
D is column 4 (1+3)
? is column ? (1+6)
Let your brains work
hahaha, thank you for all your help! -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks